#!/bin/bash

file=`ls /home/hadoop/tpcds/tpcds_sql/*.sql`
for i in $file
do
     sqlname=`basename $i`

     cat /home/hadoop/tpcds/modify/database.txt /home/hadoop/tpcds/tpcds_sql/$sqlname /home/hadoop/tpcds/modify/end.txt > /home/hadoop/tpcds/modifybak/$sqlname

done
